UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7dzobnaIDHUMmy9GyIm/tDl/D0VmI0JjF+exY8X6awU=' 
WHERE 
  key_id = '48221af1b21b0093b654d8983ef51d59cd86d8ce51f29e44d16b4aee28236652' 
  AND (
    token = '7dzobnaIDHUMmy9GyIm/tDl/D0VmI0JjF+exY8X6awU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043