UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kgTFeyoWVBOdBlFl2PyoBs8AG8wxFhqZksFTC75LGG8='
WHERE
key_id = '94df336152487d6bd3664d1e417d3b71c9f47c2b164cfd86efb54ae31627b51a'
AND (
token = 'kgTFeyoWVBOdBlFl2PyoBs8AG8wxFhqZksFTC75LGG8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)