UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DzJjwlXsOtr+/iLTuJTKBnZ4FmsiAg/ZxoiSjFTFkj8='
WHERE
key_id = 'a7ca78338fce296e92a4dcd1433ff2791567b70da3dc7bae8265916a30de3e72'
AND (
token = 'DzJjwlXsOtr+/iLTuJTKBnZ4FmsiAg/ZxoiSjFTFkj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)