UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'O57QM6/dBazAPIGafDnbfqQjMGXG1L08w5gmnH5AwVc=' 
WHERE 
  key_id = '9e669f503e715ab1b005caf5249f261f91061819aa0ca3846de46112b6f2feca' 
  AND (
    token = 'O57QM6/dBazAPIGafDnbfqQjMGXG1L08w5gmnH5AwVc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038