UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm0CnApJBFUqwqOxe2CesPmsHbm+4dIXtzVzILZx5OL0='
WHERE
key_id = '77682a9e647a445fda046e5b67a8efc080e59b72c20643d77ae2443aa69ef582'
AND (
token = 'm0CnApJBFUqwqOxe2CesPmsHbm+4dIXtzVzILZx5OL0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)