UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zz5S/XO6yvvmt3v9MdtrsygbChKgpb66a6lGjaFJwzs='
WHERE
key_id = '7d3a8574ca074cab93b354c42b3c5b544198781c93f37d9488bedd3394aa0705'
AND (
token = 'Zz5S/XO6yvvmt3v9MdtrsygbChKgpb66a6lGjaFJwzs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)