UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sByLJZgnPWxqzUr71D7nC+aHFjXFYNB+0ENXkL9eF6k='
WHERE
key_id = 'de97d8095f7dee5e415b7ba2aa1a13d39fc33a5822bbf18f1addd83a6229e3da'
AND (
token = 'sByLJZgnPWxqzUr71D7nC+aHFjXFYNB+0ENXkL9eF6k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)