UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'JJ6wVtIe4QPEoWUijD5IkO3qY1tRg9vJgHCO+uWhGM8=' 
WHERE 
  key_id = 'e5a380f5f9f9e0114a4ad56f2ab84cbcf4dc892000abc779c0d528818488d6ce' 
  AND (
    token = 'JJ6wVtIe4QPEoWUijD5IkO3qY1tRg9vJgHCO+uWhGM8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00050