UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8dmRzMfoKSjuQpH5REMXDAVI+pnuG9nSRRFBnCfWhHU='
WHERE
key_id = 'ae8f159505d84bcc8bce97740e1c3c6f36e8fd4b4eaceda05d4b10e014acabdc'
AND (
token = '8dmRzMfoKSjuQpH5REMXDAVI+pnuG9nSRRFBnCfWhHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)