UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Oo96spq2Y9aoPHyi/JKnTa87yPgCCGQ/BG7dGZq1Xok=' 
WHERE 
  key_id = '3635a1d5075b9c8df5188f8ac64a5d636254c6d222cc1ebf4394fcb9a2af2e05' 
  AND (
    token = 'Oo96spq2Y9aoPHyi/JKnTa87yPgCCGQ/BG7dGZq1Xok=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00074