UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1M1fHFYooYvF4uihtExyXdX6ER9TG6WkxyIvPgokQwM='
WHERE
key_id = '8c9a9be0ef2cbed7f45339c68f5af735d3539d3532b3f078ce9b32b82242fcee'
AND (
token = '1M1fHFYooYvF4uihtExyXdX6ER9TG6WkxyIvPgokQwM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)