UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HcFyTrMxPdvk14QIP699Q2aq61F07VDDX2CpzgOsf4k='
WHERE
key_id = 'e7c9ba38830c3a5262d405b9d3e3068633a2e58724d39e7163b6293b2d387a7d'
AND (
token = 'HcFyTrMxPdvk14QIP699Q2aq61F07VDDX2CpzgOsf4k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)