UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nHl8b/4+7h9VdplNvkaUuXd0yNoSz8baP/jZyA+vlZc='
WHERE
key_id = '0ac67f129eef7193a2038d682c83505e59a545b3853c92a82be85d149c13f72f'
AND (
token = 'nHl8b/4+7h9VdplNvkaUuXd0yNoSz8baP/jZyA+vlZc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)