UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'lEYOC9WH2RMZ3bUEDgP4qhuA78khqGzdO8u9gZGfeXg=' 
WHERE 
  key_id = '0dbe737086fd625484e9c031e752373a7a5f616e412f4f3668c368a8a8d74bfe' 
  AND (
    token = 'lEYOC9WH2RMZ3bUEDgP4qhuA78khqGzdO8u9gZGfeXg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038