UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hpUaYHMUdTsY3uJBlz7HxRGjnGtf3Gvje8XpNovBGng='
WHERE
key_id = '9cded48e3aa8ec902d2c945a8a77825369ee360b5fcea398abf970cb914622de'
AND (
token = 'hpUaYHMUdTsY3uJBlz7HxRGjnGtf3Gvje8XpNovBGng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)