UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X8k5f2OAbmg2Nc8gcQQvFb8MNBhxcE5CZr6/xHr92O8='
WHERE
key_id = '4093a4a94b468794a01cfa33aa97facbcd37eb699edc1bf8b944456700a2fe81'
AND (
token = 'X8k5f2OAbmg2Nc8gcQQvFb8MNBhxcE5CZr6/xHr92O8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)