UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'aATzeel1rHbxFDU/D9FgW6CRDKNxK5gBlP34S3EiedA=' 
WHERE 
  key_id = '5cf7ead2265ba2ad1b9ff1d616f7e9d60da852c2909c8658ad5c9e07524bfc5e' 
  AND (
    token = 'aATzeel1rHbxFDU/D9FgW6CRDKNxK5gBlP34S3EiedA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028