UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+mbTWjY9IcIUxZhGypAJYIJrfqQFseAAkRlIG0hR7j4='
WHERE
key_id = '6def717b568864f93689e0725fa18fe7584a0e4615da398f79a149e86a038948'
AND (
token = '+mbTWjY9IcIUxZhGypAJYIJrfqQFseAAkRlIG0hR7j4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)