UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lgNffbo3WobCcETv1fnLuYYsY1TimCsN55AQckj/yqw='
WHERE
key_id = 'e9a3207cb592483c02c6d5c8cb11f41a73b3b6e008da7b7cea3dbd4d32c45261'
AND (
token = 'lgNffbo3WobCcETv1fnLuYYsY1TimCsN55AQckj/yqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)