UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'FPIm5XScfpXh9nkwIKWblwrl3a4GocmK/7etAs2UM30=' 
WHERE 
  key_id = 'e15e965c56b083f0ae13f1c32b981cfe419c6888a17fe376459fd3bca8e0c63d' 
  AND (
    token = 'FPIm5XScfpXh9nkwIKWblwrl3a4GocmK/7etAs2UM30=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035