UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '26EVYznV6ytdW4uvpBMHdj29/FhO7LFEvm8NnnpLZ4o=' 
WHERE 
  key_id = '3be5e3e48a8838beb9c49d60c6e8616b779f56ca8b3dd56b3d618805d9fc1277' 
  AND (
    token = '26EVYznV6ytdW4uvpBMHdj29/FhO7LFEvm8NnnpLZ4o=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026