UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p8WoAEuX9gYtod5P33jXqRopucTBTOOgij5uZDD0wsc='
WHERE
key_id = '61a0ff43dfd4ff6b810aa21e52dfcf6d5615e6fe6654a5dbf53b02f80039a696'
AND (
token = 'p8WoAEuX9gYtod5P33jXqRopucTBTOOgij5uZDD0wsc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)