UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '14JPD86u4KKGbtEK4PeNOwq/C70r8lDJPDo64NYYnAE=' 
WHERE 
  key_id = '3f98b38bb6ea2f3b79f7b63a17c966198c4f57249e0b4f1398892fab5b053aa8' 
  AND (
    token = '14JPD86u4KKGbtEK4PeNOwq/C70r8lDJPDo64NYYnAE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027