UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uKjQTH5TYOHxiZ05w6Jzv5j29SUGpv7BV5xgBFVETLE='
WHERE
key_id = 'c9d1068996e610e57d000d6becb7ce804fd6c5797667c83015af2d3be0938577'
AND (
token = 'uKjQTH5TYOHxiZ05w6Jzv5j29SUGpv7BV5xgBFVETLE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)