UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K1zoD8+ibSR7707I8nZjvaO5uQTODNC82nOPLdZqiXM='
WHERE
key_id = '12fa9c422d30c60df9ea682ce5c4268cffdfc6adc5a2a98d7b611126d4b547a8'
AND (
token = 'K1zoD8+ibSR7707I8nZjvaO5uQTODNC82nOPLdZqiXM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)