UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'L9tt1JEZ3ofth/EZRjo2L2A976dd3UmgS5lZ8VLV/Q4=' 
WHERE 
  key_id = '62d04128f047f18d1e80eee0924a2c6ad2ab4e8e2c56e298e2bd2fbbe1c8739e' 
  AND (
    token = 'L9tt1JEZ3ofth/EZRjo2L2A976dd3UmgS5lZ8VLV/Q4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025