UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'scQE23V/bJZv7II+3qRdkYbEMginlAej9pXauozhZM4=' 
WHERE 
  key_id = '354f5717aac1cafa293bca23d96dd3b55ff9e0c2b8263507f9301f050e80539a' 
  AND (
    token = 'scQE23V/bJZv7II+3qRdkYbEMginlAej9pXauozhZM4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042