UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QXwP4iAMXo2ccxu9uMaB6Ruhz/kiQcVyrb3VcgJxdrg='
WHERE
key_id = 'e716d1607d6182ac96670bd257a74292a3834089b22731d23313e6d10337d154'
AND (
token = 'QXwP4iAMXo2ccxu9uMaB6Ruhz/kiQcVyrb3VcgJxdrg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)