UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9X+Njbt8LgSBH+hYTgT0uQZRzYh5OEKA4a8n+uF0gIE='
WHERE
key_id = '5e29ddb6acac8e83b820f0ef3071888fb4223154758d600622d74372143ff0f2'
AND (
token = '9X+Njbt8LgSBH+hYTgT0uQZRzYh5OEKA4a8n+uF0gIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)