UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JLhW12MSeaYe/yUQP3P+oLTgdhOrbdnYBkeB5mcVKrc='
WHERE
key_id = 'd08720b9dd0c409217491bbe95c93e9711b379bb07130b3b6d02400b90d670ff'
AND (
token = 'JLhW12MSeaYe/yUQP3P+oLTgdhOrbdnYBkeB5mcVKrc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)