UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8RE+DVtDyXpY3bbJR9iaFefBCeu+m8xrHBLs84J1nc0='
WHERE
key_id = '7b68cb71b4c243c481f656cf6aad38554cf63db1fde1b17348519ffbee824a90'
AND (
token = '8RE+DVtDyXpY3bbJR9iaFefBCeu+m8xrHBLs84J1nc0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)