UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8V6ZCX5Le68/aMNwGIS2HDRw2Eq1CtvFC8rvddXUJ30='
WHERE
key_id = '6493c52d2657066abd7afd29930b41c364dccf17c2c69c6d24b0b7ffd03a6d18'
AND (
token = '8V6ZCX5Le68/aMNwGIS2HDRw2Eq1CtvFC8rvddXUJ30='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)