UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZdmleeOOy5rF/vg/o94/0oHpK+/KylPLP8fsfmJf8+c='
WHERE
key_id = 'b8b3b601176e254b44729323439debcebad1949de128a4e3c847d95c903b9aba'
AND (
token = 'ZdmleeOOy5rF/vg/o94/0oHpK+/KylPLP8fsfmJf8+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)