UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7HbmP4LSgIzzskHeJXOMa6y+n0R0kY3TmgDrwk1y5tM='
WHERE
key_id = 'b46ce79778969953eb707ae51151cbf2b030b2975f29f3eaaa8f4bd706099f4a'
AND (
token = '7HbmP4LSgIzzskHeJXOMa6y+n0R0kY3TmgDrwk1y5tM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)