UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/zEO8WLeSm/E+8JX8zYxZlazvYlGiyolgvD6mWizVoY='
WHERE
key_id = '724fcc76edc6acf9cecae9be6879d85f8ef97783af80e0af0ead1d15b9401d24'
AND (
token = '/zEO8WLeSm/E+8JX8zYxZlazvYlGiyolgvD6mWizVoY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)