UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6Eeh3GcdjHAuLmchxxjfbnEg/bQFeoO9Q/PqzEeoQGU=' 
WHERE 
  key_id = '8821ac899d5ec07afa91368eef5ad66d90ee7f4966e4fb868583b40e561f528c' 
  AND (
    token = '6Eeh3GcdjHAuLmchxxjfbnEg/bQFeoO9Q/PqzEeoQGU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022