UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'msoqZNl9aRyqh8F2v808YkNpZQXrfWkd1jzXyhY57d4='
WHERE
key_id = '50d6d5657a75d881a7b6f5cbc9eb9530d576f479bed0adb6eea6244efc14608a'
AND (
token = 'msoqZNl9aRyqh8F2v808YkNpZQXrfWkd1jzXyhY57d4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)