UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5/sk9o0L6ikKveA3Yz5vmaY3VtmC8fDQoXHE9OW/XaQ=' 
WHERE 
  key_id = '8dacab5b64452ae737b1e6d210e08c76c8bd1f9c88ea108fd6f9e804f81b94a7' 
  AND (
    token = '5/sk9o0L6ikKveA3Yz5vmaY3VtmC8fDQoXHE9OW/XaQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025