UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2KSyfhPJx26fBjqH7vzbzJYJV4542yZ8WIaL3ygqPSo='
WHERE
key_id = 'b7f81d54b1f74f55f8015fdee4bf930949759ea638127e56d6424bf904deb7b2'
AND (
token = '2KSyfhPJx26fBjqH7vzbzJYJV4542yZ8WIaL3ygqPSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)