UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'CWNspi7faltmHr0TTtTCFUyiOM/7DP9ZD9Z8rEjxPAY=' 
WHERE 
  key_id = 'c32095b0ab568d2405ddba3e441940d80a2a7fc969e0df090b70f096bfe5b057' 
  AND (
    token = 'CWNspi7faltmHr0TTtTCFUyiOM/7DP9ZD9Z8rEjxPAY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022