UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U42jwbvl7T1w+W+RU33iS5NCcmgqcMhlBSejNEn8I8s='
WHERE
key_id = 'dd9347763b3d5a5f4497ce9dcd09903477d3d8edff860e4768ec98c594ab0176'
AND (
token = 'U42jwbvl7T1w+W+RU33iS5NCcmgqcMhlBSejNEn8I8s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)